﻿CREATE PROCEDURE [dbo].[ETL_SP_DeleteDtSer]
	@DtSerId uniqueidentifier
AS
	DELETE FROM ETL_DtSer WHERE Id = @DtSerId;
	DELETE FROM ETL_DtSource WHERE DtSerId = @DtSerId;
	DELETE FROM ETL_DtSourceColumn WHERE DtSerId = @DtSerId;
	DELETE FROM ETL_DtSourceParameter WHERE DtSerId = @DtSerId;
	DELETE FROM ETL_DtSourceColumnMapping WHERE DtSerId = @DtSerId;
	DELETE FROM ETL_DtSourceMapping WHERE DtSerId = @DtSerId;
RETURN 0
